if exists(select name from sysobjects where name = 'sp_LoaiKhuyenMaiGetAllByChaid')
	drop proc sp_LoaiKhuyenMaiGetAllByChaid
go
/*-- =============================================
	Created by: HP
	Created on: 2014-03-08 (dd/mm/yyyy)
	Description: 
	--

	File:$sql-scripts/Proc.sp_LoaiKhuyenMaiGetAllByChaid.sql
*/-- =============================================

CREATE PROCEDURE sp_LoaiKhuyenMaiGetAllByChaid
@LoaiKhuyenMaiChaId int
AS
BEGIN
	SELECT
		a.[LoaiKhuyenMaiId],
		a.[TenLoaiKhuyenMai]
	FROM
        LoaiKhuyenMai a where a.LoaiKhuyenMaiChaId=@LoaiKhuyenMaiChaId and trangthai<>255 
END
GO



